package com.service;

import com.dao.DB;
import java.sql.ResultSet;

public class liuService {
    public liuService() {
    }

    public static String getKefangleixingName(int id) {
        String name = "";
        String sql = "select * from t_kefangleixing where id=" + id;
        Object[] params = new Object[0];
        DB mydb = new DB();

        try {
            mydb.doPstm(sql, params);
            ResultSet rs = mydb.getRs();
            rs.next();
            name = rs.getString("name");
            rs.close();
        } catch (Exception var6) {
            var6.printStackTrace();
        }

        mydb.closed();
        return name;
    }

    public static String getKefangFangjianhao(int id) {
        String fangjianhao = "";
        String sql = "select * from t_kefang where del='no' and id=" + id;
        Object[] params = new Object[0];
        DB mydb = new DB();

        try {
            mydb.doPstm(sql, params);
            ResultSet rs = mydb.getRs();
            rs.next();
            fangjianhao = rs.getString("fangjianhao");
            rs.close();
        } catch (Exception var6) {
            var6.printStackTrace();
        }

        mydb.closed();
        return fangjianhao;
    }
}
